package net.hn.hnms.biz.safety.monitor.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import net.hn.hnms.biz.safety.monitor.domain.BaseSensorInfoNowPo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 测点实时基本信息
 */
public interface BaseSensorInfoNowMapper extends BaseMapper<BaseSensorInfoNowPo> {

    @Select("select base.point_code,point_monitor_location from dwd_aqjk_now_base_sensorinfo base  JOIN dwd_aqjk_now_sensormonitor now on base.point_code=now.point_code WHERE  base.mine_code = #{mineCode} AND base.sensor_type_name =#{sensorTypeName} GROUP BY base.point_code,point_monitor_location ORDER BY point_monitor_location")
    List<BaseSensorInfoNowPo> selecBasetList(@Param("mineCode") String mineCode, @Param("sensorTypeName") String sensorTypeName);
}
